package com.edu.zju.scs.panacea.mapper.exposure;

import com.edu.zju.scs.panacea.entity.exposure.CrowdPortrayal;
import com.edu.zju.scs.panacea.entity.exposure.Exposure;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Author: Yue Liang
 * @Date: 2019-02-08 21:14
 */
@Repository
public interface CrowdPortrayalMapper {
    @Select("SELECT * FROM test_user_label WHERE mac = #{mac}")
    @Results(id="crowdPortrayalMap", value={
            @Result(property="mac",column="mac"),
            @Result(property="age",column="age"),
            @Result(property="education",column="education"),
            @Result(property="marriage",column="marriage"),
            @Result(property="manageMoney",column="manage_Money"),
            @Result(property="recreation",column="recreation"),
            @Result(property="game",column="game"),
            @Result(property="shopping",column="shopping"),
            @Result(property="trip",column="trip"),
            @Result(property="car",column="car"),
            @Result(property="infantMom",column="infant_mom"),
            @Result(property="socialContact",column="social_contact"),
            @Result(property="sport",column="sport"),
            @Result(property="life",column="life")})
    CrowdPortrayal selectCrowdPortrayal(String mac);

}
